--***********************************************************
--SELECT Stored Procedure for <Table> table
--***********************************************************
GO

USE <Database>
GO


IF EXISTS (SELECT sys.objects.name FROM sys.objects INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id WHERE sys.objects.name = '<TableU>Select_Records'  and sys.schemas.name = '<Owner>'  and sys.objects.type = 'P') 
DROP PROCEDURE [<Owner>].[<TableU>Select_Records] 
GO

CREATE PROCEDURE [<Owner>].[<TableU>Select_Records]
<If Loop>
     <IsFKey>
     <And>
     <IsNotComboBox (Db)>
     @<DRField> <SQLType>
</If Loop>
AS 
BEGIN 
SELECT 
<If Loop>
     <IsComboBox (Db)>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>]
     <IsComboBox (Db)>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>]
     <IsComboBox (Db)>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsComboBox (Db)>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotComboBox (Db)>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotComboBox (Db)>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
     [<DOwner>].[<DTable>].[<DRField>] = @<DRField>
END 
GO

GRANT EXECUTE ON [<Owner>].[<TableU>Select_Records] TO [Public]
GO

